package com.sasu.university_data.mapper;/*
@author luoye
@create 2024-04-16-21:30
*/


import com.sasu.university_data.entity.WorkPlace;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface WorkPlaceMapper {
    List<WorkPlace> queryWorkPlaceById( Integer id);

    /**
     * 统计总行数
     *
     * @return 总行数
     */
    long count(@Param("loc")String loc);

    /***
     * 分页查询/根据学校名模糊查询再分页
     * @param page
     * @param pageSize
     * @return
     */
    List<WorkPlace> selectByPage(@Param("loc") String loc, @Param("page") Integer page, @Param("pageSize") Integer pageSize);
    int insert( WorkPlace workPlace);
    int update(WorkPlace workPlace);

    int deleteById(Integer wId);
    /***
     * 通过id批量删除
     * @param wIds
     * @return
     */
    int deleteByIds(@Param("IDS") int[] wIds);

}
